<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: currencies.php 38 2013-09-21 11:55:27Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 38 $
* 	zuletzt geaendert von:	$Author: siekiera $
* 	Datum:					$Date: 2013-09-21 11:55:27 +0000 (Sat, 21 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */

require('includes/application_top.php');

require(DIR_WS_CLASSES.'currencies.php');
$currencies = new currencies();

if ($_GET['action']) {
	switch ($_GET['action']) {
		case 'insert':
		case 'save':
			$currency_id = $_GET['cID'];
			$title = $_POST['title'];
			$code = $_POST['code'];
			$symbol_left = $_POST['symbol_left'];
			$symbol_right = $_POST['symbol_right'];
			$decimal_point = $_POST['decimal_point'];
			$thousands_point = $_POST['thousands_point'];
			$decimal_places = $_POST['decimal_places'];
			$value = $_POST['value'];

			$sql_data_array = array('title' => $title,
									'code' => $code,
									'symbol_left' => $symbol_left,
									'symbol_right' => $symbol_right,
									'decimal_point' => $decimal_point,
									'thousands_point' => $thousands_point,
									'decimal_places' => $decimal_places,
									'value' => $value);

			if($_GET['action'] == 'insert') {
				$db->db_perform(TABLE_CURRENCIES, $sql_data_array);
				$currency_id = $db->db_insert_id();

			} elseif ($_GET['action'] == 'save')
				$db->db_perform(TABLE_CURRENCIES, $sql_data_array, 'update', "currencies_id = ".$db->db_prepare($currency_id));

			if($_POST['default'] == 'on')
				$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = ".$db->db_prepare($code)." WHERE configuration_key = 'DEFAULT_CURRENCY'");

			redirect(href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$currency_id));
		break;

		case 'deleteconfirm':
			$currencies_id = $_GET['cID'];

			$currency = $db->db_query("SELECT currencies_id FROM ".TABLE_CURRENCIES." WHERE code = '".DEFAULT_CURRENCY."'");

			if($currency->fields['currencies_id'] == $currencies_id)
				$db->db_query("UPDATE ".TABLE_CONFIGURATION." SET configuration_value = '' WHERE configuration_key = 'DEFAULT_CURRENCY'");

			$db->db_query("DELETE FROM ".TABLE_CURRENCIES." WHERE currencies_id = ".$db->db_prepare($currencies_id));

			redirect(href_link(FILENAME_CURRENCIES, 'page='.$_GET['page']));
		break;

		case 'update':
			$currency = $db->db_query("SELECT currencies_id, code, title FROM ".TABLE_CURRENCIES);
			while(!$currency->EOF) {
				$quote_function = 'quote_'.CURRENCY_SERVER_PRIMARY.'_currency';
				$rate = $quote_function($currency->fields['code']);
				if((!$rate) && (CURRENCY_SERVER_BACKUP != '')) {
					$quote_function = 'quote_'.CURRENCY_SERVER_BACKUP.'_currency';
					$rate = $quote_function($currency->fields['code']);
				}
				if($rate) {
					$db->db_query("UPDATE ".TABLE_CURRENCIES." SET value = '".$rate."', last_updated = NOW() WHERE currencies_id = '".$currency->fields['currencies_id']."'");
					$message_stack->add_session(sprintf(TEXT_INFO_CURRENCY_UPDATED, $currency->fields['title'], $currency->fields['code']), 'success');
				} else
					$message_stack->add_session(sprintf(ERROR_CURRENCY_INVALID, $currency->fields['title'], $currency->fields['code']), 'error');
			}
			redirect(href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$_GET['cID']));
		break;

		case 'delete':
			$currencies_id = $_GET['cID'];

			$currency = $db->db_query("SELECT code FROM ".TABLE_CURRENCIES." WHERE currencies_id = ".$db->db_prepare($currencies_id));

			$remove_currency = true;
			if ($currency->fields['code'] == DEFAULT_CURRENCY) {
				$remove_currency = false;
			$message_stack->add(ERROR_REMOVE_DEFAULT_CURRENCY, 'error');
		}
		break;
	}
}
require(DIR_WS_INCLUDES.'metatag.php');
?>
</head>
<body>
<?php require(DIR_WS_INCLUDES.'header.php'); ?>
<div id="wrapper">
<table class="outerTable" cellspacing="0" cellpadding="0">
  <tr>
    <td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top">
		<?php require(DIR_WS_INCLUDES.'column_left.php'); ?>
	</td>
    <td class="boxCenter" valign="top">
    <table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
         <td>
			<table class="table_pageHeading" border="0" width="100%" cellspacing="0" cellpadding="0">
			  <tr>
			    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
			  </tr>
			</table>
		</td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table width="100%" cellspacing="0" cellpadding="0" class="dataTable">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CURRENCY_NAME; ?></td>
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CURRENCY_CODES; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_CURRENCY_VALUE; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
              </tr>
				<?php
				  $currency = $db->db_query("SELECT 
				  									currencies_id, 
				  									title, 
				  									code, 
				  									symbol_left, 
				  									symbol_right, 
				  									decimal_point, 
				  									thousands_point, 
				  									decimal_places, 
				  									last_updated, 
				  									value 
				  								FROM 
				  									".TABLE_CURRENCIES." 
				  								ORDER BY 
				  									title");
				  
				  while(!$currency->EOF) { $rows++;
				    if (((!$_GET['cID']) || (@$_GET['cID'] == $currency->fields['currencies_id'])) && (!$cInfo) && (substr($_GET['action'], 0, 3) != 'new')) {
				      $cInfo = new objectInfo($currency->fields);
				    }

				    if ( (is_object($cInfo)) && ($currency->fields['currencies_id'] == $cInfo->currencies_id) ) {
				      echo '<tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'pointer\'" onclick="document.location.href=\''.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=edit').'\'">'."\n";
				    } else {
						if ($rows % 2 == 0)
				    		$f = 'dataTableRow';
				    	else
				    		$f = '';
				      	echo '<tr class="'.$f.'" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'pointer\'" onmouseout="this.className=\''.$f.'\'" onclick="document.location.href=\''.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$currency->fields['currencies_id']).'\'">'."\n";
				    }

				    if (DEFAULT_CURRENCY == $currency->fields['code']) {
				      echo '<td class="dataTableContent"><b>'.$currency->fields['title'].' ('.TEXT_DEFAULT.')</b></td>'."\n";
				    } else {
				      echo '<td class="dataTableContent">'.$currency->fields['title'].'</td>'."\n";
				    }
				?>
                <td class="dataTableContent"><?php echo $currency->fields['code']; ?></td>
                <td class="dataTableContent" align="right"><?php echo number_format($currency->fields['value'], 8); ?></td>
                <td class="dataTableContent" align="right">
					<?php if ( (is_object($cInfo)) && ($currency->fields['currencies_id'] == $cInfo->currencies_id) ) {
							echo image(DIR_WS_IMAGES.'icon_arrow_right.gif');
						} else {
							echo '<a href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$currency->fields['currencies_id']).'">'.image(DIR_WS_IMAGES.'icon_info.gif', IMAGE_ICON_INFO).'</a>';
						} ?>&nbsp;</td>
				<?php
					echo '</tr>';
					$currency->MoveNext();
				  }
				?>
            </table>
			<table border="0" width="100%" cellspacing="0" cellpadding="2">
				<?php
				  if (!$_GET['action']) {
				?>
              <tr>
                <td><?php if (CURRENCY_SERVER_PRIMARY) { echo '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=update').'">'.BUTTON_UPDATE_CURRENCY.'</a>'; } ?></td>
                <td align="right"><?php echo '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=new').'">'.BUTTON_NEW_CURRENCY.'</a>'; ?></td>
              </tr>
				<?php
			      }
				?>
            </table>
		</td>
		<?php
		  $heading = array();
		  $contents = array();
		  switch ($_GET['action']) {
		    case 'new':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_NEW_CURRENCY.'</b>');

		      $contents = array('form' => draw_form('currencies', FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=insert'));
		      $contents[] = array('text' => TEXT_INFO_INSERT_INTRO);
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_TITLE.'<br />'.draw_input_field('title'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_CODE.'<br />'.draw_input_field('code'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_SYMBOL_LEFT.'<br />'.draw_input_field('symbol_left'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_SYMBOL_RIGHT.'<br />'.draw_input_field('symbol_right'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_DECIMAL_POINT.'<br />'.draw_input_field('decimal_point'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_THOUSANDS_POINT.'<br />'.draw_input_field('thousands_point'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_DECIMAL_PLACES.'<br />'.draw_input_field('decimal_places'));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_VALUE.'<br />'.draw_input_field('value'));
		      $contents[] = array('text' => '<br />'.draw_checkbox_field('default').' '.TEXT_INFO_SET_AS_DEFAULT);
		      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'.BUTTON_INSERT.'</button> <a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$_GET['cID']).'">'.BUTTON_CANCEL.'</a>');
		      break;

		    case 'edit':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_EDIT_CURRENCY.'</b>');

		      $contents = array('form' => draw_form('currencies', FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=save'));
		      $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_TITLE.'<br />'.draw_input_field('title', $cInfo->title));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_CODE.'<br />'.draw_input_field('code', $cInfo->code));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_SYMBOL_LEFT.'<br />'.draw_input_field('symbol_left', $cInfo->symbol_left));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_SYMBOL_RIGHT.'<br />'.draw_input_field('symbol_right', $cInfo->symbol_right));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_DECIMAL_POINT.'<br />'.draw_input_field('decimal_point', $cInfo->decimal_point));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_THOUSANDS_POINT.'<br />'.draw_input_field('thousands_point', $cInfo->thousands_point));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_DECIMAL_PLACES.'<br />'.draw_input_field('decimal_places', $cInfo->decimal_places));
		      $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_VALUE.'<br />'.draw_input_field('value', $cInfo->value));
		      if (DEFAULT_CURRENCY != $cInfo->code) $contents[] = array('text' => '<br />'.draw_checkbox_field('default').' '.TEXT_INFO_SET_AS_DEFAULT);
		      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'. BUTTON_UPDATE.'</button> <a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id).'">'.BUTTON_CANCEL.'</a>');
		      break;

		    case 'delete':
		      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_DELETE_CURRENCY.'</b>');

		      $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
		      $contents[] = array('text' => '<br /><b>'.$cInfo->title.'</b>');
		      $contents[] = array('align' => 'center', 'text' => '<br />'.(($remove_currency) ? '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=deleteconfirm').'">'.BUTTON_DELETE.'</a>' : '').' <a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id).'">'.BUTTON_CANCEL.'</a>');
		      break;

		    default:
		      if (is_object($cInfo)) {
		        $heading[] = array('text' => '<b>'.$cInfo->title.'</b>');

		        $contents[] = array('align' => 'center', 'text' => '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=edit').'">'.BUTTON_EDIT.'</a> <a class="button" onClick="this.blur();" href="'.href_link(FILENAME_CURRENCIES, 'page='.$_GET['page'].'&cID='.$cInfo->currencies_id.'&action=delete').'">'.BUTTON_DELETE.'</a>');
		        $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_TITLE.' '.$cInfo->title);
		        $contents[] = array('text' => TEXT_INFO_CURRENCY_CODE.' '.$cInfo->code);
		        $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_SYMBOL_LEFT.' '.$cInfo->symbol_left);
		        $contents[] = array('text' => TEXT_INFO_CURRENCY_SYMBOL_RIGHT.' '.$cInfo->symbol_right);
		        $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_DECIMAL_POINT.' '.$cInfo->decimal_point);
		        $contents[] = array('text' => TEXT_INFO_CURRENCY_THOUSANDS_POINT.' '.$cInfo->thousands_point);
		        $contents[] = array('text' => TEXT_INFO_CURRENCY_DECIMAL_PLACES.' '.$cInfo->decimal_places);
		        $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_LAST_UPDATED.' '.date_short($cInfo->last_updated));
		        $contents[] = array('text' => TEXT_INFO_CURRENCY_VALUE.' '.number_format($cInfo->value, 8));
		        $contents[] = array('text' => '<br />'.TEXT_INFO_CURRENCY_EXAMPLE.'<br />'.$currencies->format('30', false, DEFAULT_CURRENCY).' = '.$currencies->format('30', true, $cInfo->code));
		      }
		      break;
		  }

		  if ( (not_null($heading)) && (not_null($contents)) ) {
		    echo '            <td width="25%" class="border" valign="top">'."\n";

		    $box = new box;
		    echo $box->infoBox($heading, $contents);

		    echo '            </td>'."\n";
		  }
		?>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
</div>
<?php require(DIR_WS_INCLUDES.'footer.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES.'application_bottom.php'); ?>